using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.DataControl;
using System.Data.DataModel;

namespace WebAppWithDataEnum.Model
{
	public class SampleClass:BaseModel
	{
		public SampleClass() : base()
		{
			this.dbController.SelectAllCommand = this.selectAllString;
			this.dbController.SelectCommand = this.selectString;
			this.dbController.InsertCommand = this.insertString;
			this.dbController.UpdateCommand = this.updateString;
			this.dbController.DeleteCommand = this.deleteString;
		}
		private string selectAllString = "SELECT SampleCode,SampleName,WinterDay FROM SampleClass ";
		private string selectString = "SELECT SampleCode,SampleName,WinterDay FROM SampleClass  WHERE SampleCode = :SampleCode";
		private string updateString = "UPDATE SampleClass SET  SampleName=:SampleName, WinterDay=:WinterDay WHERE SampleCode = :SampleCode";
		private string insertString = "INSERT INTO SampleClass( SampleCode, SampleName, WinterDay) VALUES( :SampleCode, :SampleName, :WinterDay)";
		private string deleteString = "DELETE FROM SampleClass WHERE SampleCode = :SampleCode";
		public System.Int32 SampleCode{ get; set; }

		public System.String SampleName{ get; set; }

		public System.DateTime WinterDay{ get; set; }


	}
}
